﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace BLSingTowerMall
{
    public class AvailableStoreForPromotion
    {
        private DBSingTowerMallEntities cntx = new DBSingTowerMallEntities();

        public IQueryable<Int32> getAvailableStoresForPromotion(string userName)
        //public IQueryable<IEventHall> getAvailableEventHalls()
        {



            //var storeIds = from s in cntx.StoreBookings where s.UserName == userName
            //            select s.StoreID;

            var storeIds = from s in cntx.Stores
                           where s.UserName == userName
                           select s.StoreID;

            return storeIds;


            //IQueryable<IEventHall> availableHallsList = (from f in cntx.EventHalls where f.HallID == cntx.EventHallBookings. select f);
            //return availableHallsList;

        }
    }
}
